会员可以在此提问,百战程序员老师有问必答
对大家有帮助的问答会被标记为“推荐”
看完课程过来浏览一下别人提的问题,会帮你学得更全面
截止目前,同学们一共提了 133786个问题

com.itbaizhan.SocketDemo;

java.io.BufferedReader;
java.io.InputStreamReader;
java.io.PrintWriter;
java.net.ServerSocket;
java.net.Socket;
java.util.Scanner;
Send1 Thread{
    Socket ;
    Scanner ;
    Send1(Socket socket,Scanner scanner){
        .=scanner;
        .=socket;
    }

    run() {
        .SendMsg();
    }
    SendMsg(){
        (PrintWriter pw=PrintWriter(.getOutputStream());){
            (){
                String msg=.nextLine();
                pw.println(msg);
                pw.flush();
            }
        }
        (Exception e){
            e.printStackTrace();}
    }
}
Receive1 Thread{
    Socket ;
    Receive1(Socket socket){
        .=socket;
    }

    run() {
        .receiveMsg();
    }
    receiveMsg(){
        (BufferedReader br=BufferedReader( InputStreamReader(.getInputStream()));
        ){
            (){
                String msg=br.readLine();
                System..println(+msg);
            }
        }
        (Exception e){
            e.printStackTrace();}

    }
}
GoodTCP {
    main(String[] args) {
        ServerSocket serverSocket=;
        Socket socket=;
        {
            Scanner scanner=Scanner(System.);
            System..println();
            String str= scanner.nextLine();
            String[] arr=str.split();
            String[] split=str.split();
            (.equals(arr[])){
                System..println(+arr[]+);
                serverSocket =ServerSocket(Integer.(arr[]));
                 socket = serverSocket.accept();

            }{
                socket =Socket(arr[],Integer.(arr[]));
                System..println();

            }
            Send1(socket,scanner).start();
            Receive1(socket).start();
        }
        (Exception e){
            e.printStackTrace();
        }{
            (serverSocket!=){
                {
                    serverSocket.close();
                }(Exception e){
                    e.printStackTrace();
                }
            }
        }
    }
}



com.itbaizhan.SocketDemo;

java.io.BufferedReader;
java.io.InputStreamReader;
java.io.PrintWriter;
java.net.ServerSocket;
java.net.Socket;

Msg Thread{
    Socket ;
    Msg(Socket socket){
        .= socket;
    }
    run() {
        .msg();
    }

    msg(){
        (BufferedReader br = BufferedReader(InputStreamReader(..getInputStream()));
            PrintWriter pw = PrintWriter(..getOutputStream())){
            (){
                pw.println(br.readLine()+);
                pw.flush();
            }
        }(Exception e){
            e.printStackTrace();
            System..println(..getInetAddress()+);
        }
    }
}
EchoServer {
    main(String[] args) {
        (ServerSocket serverSocket = ServerSocket()){
            (){
                Socket socket = serverSocket.accept();
                Msg(socket).start();
            }
        }(Exception e){
            e.printStackTrace();
        }
    }
}

不知道为什么会报错,代码运行没问题。image.png

JAVA 全系列/第二阶段:JAVA 基础深化和提高/网络编程 34801楼
Python 全系列/第二阶段:Python 深入与提高/GUI编程(隐藏) 34802楼
JAVA 全系列/第十九阶段:亿级高并发电商项目/亿级高并发电商项目(旧) 34803楼
Python 全系列/第二阶段:Python 深入与提高/异常机制 34804楼
JAVA 全系列/第六阶段:项目管理与SSM框架/RBAC实战 34805楼
Python 全系列/第一阶段:AI驱动的Python编程/Python入门(动画版) 34808楼

Exception in thread "main" org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into orders value(default,?,null)]; Data truncated for column 'orderprice' at row 1; nested exception is java.sql.SQLException: Data truncated for column 'orderprice' at row 1

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)

at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:862)

at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:917)

at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:927)

at com.aliyun.sailorzhao.spring.tx.dao.UserDaoImp.insertOrder(UserDaoImp.java:31)

at com.aliyun.sailorzhao.spring.tx.service.UserServiceImp.addUserAndOrder(UserServiceImp.java:21)

at com.aliyun.sailorzhao.spring.tx.Test.test1(Test.java:23)

at com.aliyun.sailorzhao.spring.tx.Test.main(Test.java:12)

Caused by: java.sql.SQLException: Data truncated for column 'orderprice' at row 1

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)

at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2133)

at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2067)

at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5175)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2052)

at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:867)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)

... 7 more

这个是我爸哪里搞错了呢?

// UserDaoImp.java

@Override

public void insertOrder(Order order) {

String sql = "insert into orders value(default,?,null)";

Object args = new Object[] { order.getOrderprice() };

this.jdbcTemplate.update(sql, args);

}

// Test.java

Order order = new Order();

order.setOrderprice(113);

userService.addUserAndOrder(user, order);


JAVA 全系列/第六阶段:项目管理与SSM框架/Spring 34810楼
JAVA 全系列/第八阶段:生产环境部署与协同开发/Linux 34813楼
Python 全系列/第一阶段:AI驱动的Python编程/序列 34815楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

©2014-2025百战汇智(北京)科技有限公司 All Rights Reserved 北京亦庄经济开发区科创十四街 赛蒂国际工业园
网站维护:百战汇智(北京)科技有限公司
京公网安备 11011402011233号    京ICP备18060230号-3    营业执照    经营许可证:京B2-20212637